USE TrollAMAP
GO
-- Create user
CREATE USER [lesmarrons] FOR LOGIN [lesmarrons]
GO

-- Grant rights
GRANT select on OFFRE to lesmarrons
GRANT select on PRODUIT to lesmarrons
GRANT select, insert, update on COMMANDE_AMAP to lesmarrons
GO


USE AMAP
GO
-- Create user
CREATE USER [Julien] FOR LOGIN [Julien]
GO

-- Grant rights
GRANT select on Offers to Julien
GRANT exec on sp_ReadRequestId to Julien
GRANT exec on sp_RequestProduct to Julien
GO